use adventureworks;
select * from Production.Product

Select Name, Productnumber, standardcost, listprice
from Production.Product


Select Name, ProductNumber, Standardcost, listprice
From Production.Product
Where StandardCost>0


Select Name, ProductNumber, Standardcost, listprice
From Production.Product
Where ProductNumber Like'CN%'


Select Name, ProductNumber, Standardcost, listprice
From Production.Product
WHERE StandardCost > 0 And StandardCost<100



Select Name, ProductNumber, Standardcost, listprice
From Production.Product
WHERE StandardCost between 0 and  100


Select Name, ProductNumber, Standardcost, listprice
From Production.Product
WHERE EXISTs
(Select * FROM Production.Product Where ProductNumber Like '[A-C]%')




Select Name, ProductNumber, Standardcost, listprice
From Production.Product
Order by name
Collate SQL_Lithuanian_CP1257_CS_AS